/*
Navicat MySQL Data Transfer

Source Server         : Localhost
Source Server Version : 50612
Source Host           : localhost:3306
Source Database       : server

Target Server Type    : MYSQL
Target Server Version : 50612
File Encoding         : 65001

Date: 2013-10-25 22:35:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(42) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password`  varchar(42) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`accesslevel`  int(4) NOT NULL DEFAULT 70 COMMENT '0 : Banni\r\n70 : Joueur\r\n76 : Maitre du jeu\r\n80 : Administrateur' ,
`bantime`  int(20) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of accounts
-- ----------------------------
BEGIN;
INSERT INTO `accounts` VALUES ('1', 'admin', '89d1ed22aac58f5bbea53b2fde81a946', '80', '0'), ('2', 'test', '89d1ed22aac58f5bbea53b2fde81a946', '70', '0');
COMMIT;

-- ----------------------------
-- Table structure for `characters`
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`account`  int(11) NOT NULL DEFAULT 0 ,
`name`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`place`  int(11) NOT NULL DEFAULT 0 ,
`sex`  int(11) NOT NULL DEFAULT 0 ,
`job`  int(11) NOT NULL DEFAULT 0 ,
`hair`  int(11) NOT NULL DEFAULT 0 ,
`hairColor`  int(11) NOT NULL DEFAULT 0 ,
`head`  int(11) NULL DEFAULT NULL ,
`stat_FOR`  int(11) NOT NULL DEFAULT 15 ,
`stat_END`  int(11) NOT NULL DEFAULT 15 ,
`stat_DEX`  int(11) NOT NULL DEFAULT 15 ,
`stat_INT`  int(11) NOT NULL DEFAULT 15 ,
`penya`  int(11) NOT NULL DEFAULT 15000 ,
`level`  int(11) NOT NULL DEFAULT 1 ,
`bankpass`  int(11) NOT NULL DEFAULT 1234 ,
`worldid`  int(11) NOT NULL DEFAULT 1 ,
`pos_X`  float NOT NULL DEFAULT 6968 ,
`pos_Y`  float NOT NULL DEFAULT 100 ,
`pos_Z`  float NOT NULL DEFAULT 3328.8 ,
`rotation`  int(11) NOT NULL DEFAULT 0 ,
`HP`  int(11) NOT NULL DEFAULT 230 ,
`FP`  int(11) NOT NULL DEFAULT 32 ,
`MP`  int(11) NOT NULL DEFAULT 63 ,
`exp`  bigint(20) NOT NULL DEFAULT 0 ,
`skillPoints`  int(11) NOT NULL DEFAULT 0 ,
`statPoints`  int(11) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=27

;

-- ----------------------------
-- Records of characters
-- ----------------------------
BEGIN;
INSERT INTO `characters` VALUES ('25', '2', 'Test', '0', '0', '0', '2', '-6391955', '2', '15', '15', '15', '15', '15000', '3', '1234', '1', '6984.5', '100.001', '3420.28', '2855', '111', '33', '64', '16', '4', '4'), ('26', '1', 'Loicator', '0', '0', '0', '3', '-3695516', '3', '15', '15', '15', '15', '15000', '4', '1234', '1', '7006.12', '100', '3586.83', '1912', '116', '33', '64', '7', '6', '6');
COMMIT;

-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`characterid`  int(11) NOT NULL DEFAULT 0 ,
`place`  int(11) NOT NULL DEFAULT 0 ,
`type`  tinyint(4) NOT NULL DEFAULT 1 ,
`itemid`  int(11) NOT NULL DEFAULT 0 ,
`count`  int(11) NOT NULL DEFAULT 1 ,
PRIMARY KEY (`characterid`, `place`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of items
-- ----------------------------
BEGIN;
INSERT INTO `items` VALUES ('25', '0', '1', '2800', '5'), ('25', '1', '1', '2801', '1'), ('25', '2', '1', '4805', '5'), ('25', '44', '1', '502', '1'), ('25', '46', '1', '506', '1'), ('25', '47', '1', '510', '1'), ('25', '52', '1', '21', '1'), ('26', '0', '1', '2800', '5'), ('26', '1', '1', '2801', '1'), ('26', '2', '1', '4805', '5'), ('26', '44', '1', '502', '1'), ('26', '46', '1', '506', '1'), ('26', '47', '1', '510', '1'), ('26', '52', '1', '21', '1');
COMMIT;

-- ----------------------------
-- Auto increment value for `accounts`
-- ----------------------------
ALTER TABLE `accounts` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for `characters`
-- ----------------------------
ALTER TABLE `characters` AUTO_INCREMENT=27;
